| CampusGroup |
| EntityType | Independent |
| Logical Entity Name | CampusGroup |
| Default Table Name | SyCampusGrp |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| CampusGroup Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
CampusGroupId |
INTEGER | NO | ||
| Code | CHAR(16) | NO | ||
| Name | VARCHAR(35) | NO | ||
| LastModifiedUserId | INTEGER | NO | ||
| IsSystemCode | BIT | NO | ||
| SaStmtComments | VARCHAR(1000) | YES | ||
| SaStmtLastCloseDate | DATETIME | YES | ||
| ModFlag | CHAR(1) | NO | ||
| Type | CHAR(1) | NO | ||
| IsActive | BIT | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| FinancialCampusGroup | BIT | NO |
| CampusGroup Keys |
| Key Name | Key Type | Keys |
| SyCampusGrp_Type_SyCampusGRPID_U_N_IDX | Alternate Key | Type, CampusGroupId |
| SyCampusGrp_Type_Code_N_N_IDX | Inversion Entry | Type, Code |
| SyCampusGrp_Code_N_N_IDX | Inversion Entry | Code |
| SyCampusGrp_SyCampusGrpID_U_C_IDX | PrimaryKey | CampusGroupId |
| CampusGroup Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SevisCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| SchoolStartDate | Non-Identifying | One To Zero or More | NO | ||||
| ShiftSchoolStartDate | Non-Identifying | One To Zero or More | NO | ||||
| CourseAttribute | Non-Identifying | One To Zero or More | NO | ||||
| CatalogYear | Non-Identifying | One To Zero or More | NO | ||||
| AdClassSchedCancelReason | Non-Identifying | One To Zero or More | NO | ||||
| AreaOfStudy | Non-Identifying | One To Zero or More | NO | ||||
| AdCourseFulfillmentOrder | Non-Identifying | One To Zero or More | NO | ||||
| AdCoursePrefix | Non-Identifying | One To Zero or More | NO | ||||
| StudentCourseStatusChangeReason | Non-Identifying | One To Zero or More | NO | ||||
| AdFinalGradeReason | Non-Identifying | One To Zero or More | NO | ||||
| GpaCalculationType | Non-Identifying | One To Zero or More | NO | ||||
| AdLesson | Non-Identifying | One To Zero or More | NO | ||||
| AdLessonPlan | Non-Identifying | One To Zero or More | NO | ||||
| AdLocation | Non-Identifying | One To Zero or More | NO | ||||
| AdProgramTermsInAY | Non-Identifying | One To Zero or More | NO | ||||
| RegistrationGroup | Non-Identifying | One To Zero or More | NO | ||||
| TermProgramAssociation | Non-Identifying | One To Zero or More | NO | ||||
| AdTermProgramAssociation | Non-Identifying | One To Zero or More | NO | ||||
| ApplicationForm | Non-Identifying | One To Zero or More | NO | ||||
| EntranceTestLocation | Non-Identifying | One To Zero or More | NO | ||||
| CmDocMgmtSftDetail | Non-Identifying | One To Zero or More | NO | ||||
| ExcusedAbsencePolicyCode | Non-Identifying | One To Zero or More | NO | ||||
| FaTermAssociationTrack | Non-Identifying | One To Zero or More | NO | ||||
| FaTermAssociationTrackProgramVersion | Non-Identifying | One To Zero or More | NO | ||||
| FaTermTrack | Non-Identifying | One To Zero or More | NO | ||||
| HousingBuilding | Non-Identifying | One To Zero or More | NO | ||||
| HsBuildingCategories | Non-Identifying | One To Zero or More | NO | ||||
| HsHousingDates | Non-Identifying | One To Zero or More | NO | ||||
| HsRoomCategories | Non-Identifying | One To Zero or More | NO | ||||
| HsSuiteCategories | Non-Identifying | One To Zero or More | NO | ||||
| EmployerAttribute | Non-Identifying | One To Zero or More | NO | ||||
| Certification | Non-Identifying | One To Zero or More | NO | ||||
| EmployerCareerField | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactJobSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactSoftSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerSoftSkill | Non-Identifying | One To Zero or More | NO | ||||
| JobBenefit | Non-Identifying | One To Zero or More | NO | ||||
| AccountStatus | Non-Identifying | One To Zero or More | NO | ||||
| GeneralLedgerReleaseBatch | Non-Identifying | One To Zero or More | NO | ||||
| JournalEntry | Non-Identifying | One To Zero or More | NO | ||||
| SubsidiaryAccountType | Non-Identifying | One To Zero or More | NO | ||||
| TuitionDiscountPolicy | Non-Identifying | One To Zero or More | NO | ||||
| AthleticStatus | Non-Identifying | One To Zero or More | NO | ||||
| DisabilityStatus | Non-Identifying | One To Zero or More | NO | ||||
| StudentAthleteRecruitmentType | Non-Identifying | One To Zero or More | NO | ||||
| StudentServicesRoomType | Non-Identifying | One To Zero or More | NO | ||||
| ServiceType | Non-Identifying | One To Zero or More | NO | ||||
| ServiceTypeCategory | Non-Identifying | One To Zero or More | NO | ||||
| Sport | Non-Identifying | One To Zero or More | NO | ||||
| SyEmpGroups | Non-Identifying | One To Zero or More | NO | ||||
| SyEmpGrp | Non-Identifying | One To Zero or More | NO | ||||
| syIMSConfiguration | Non-Identifying | One To Zero or More | NO | ||||
| SyIndicator | Non-Identifying | One To Zero or More | NO | ||||
| SyOrganization | Non-Identifying | One To Zero or More | NO | ||||
| SyResidencyStatus | Non-Identifying | One To Zero or More | NO | ||||
| SyResidencyType | Non-Identifying | One To Zero or More | NO | ||||
| SevisCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| StaffGroupTemplateSetting | Non-Identifying | One To Zero or More | NO |
| CampusGroup Check Constraints |
| Check Constraint Name | CheckConstraint |
| CampusGroup Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.CampusGroup |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyCampusGrp |
NO |
| CampusGroup Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | SEVIS |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Academic Records |
| Physical (Microsoft SQL Server) | System |
| CampusGroup Data Movement Rules |
| Name | Type | Rule Text/Value |